/*
 Navicat Premium Data Transfer

 Source Server         : docker-mysql
 Source Server Type    : MySQL
 Source Server Version : 50651
 Source Host           : localhost:3306
 Source Schema         : easyadmin

 Target Server Type    : MySQL
 Target Server Version : 50651
 File Encoding         : 65001

 Date: 23/09/2021 12:09:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ea_cost_budget
-- ----------------------------
DROP TABLE IF EXISTS `ea_cost_budget`;
CREATE TABLE `ea_cost_budget` (
                                  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                  `classify_id` int(11) NOT NULL COMMENT '分类id',
                                  `company_id` int(11) NOT NULL COMMENT '城市id',
                                  `budget_time` int(11) NOT NULL COMMENT '日期',
                                  `budget_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
                                  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
                                  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                  PRIMARY KEY (`id`),
                                  KEY `index_budget_time` (`budget_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预算费用表';

-- ----------------------------
-- Records of ea_cost_budget
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ea_cost_classify
-- ----------------------------
DROP TABLE IF EXISTS `ea_cost_classify`;
CREATE TABLE `ea_cost_classify` (
                                    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                    `pid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
                                    `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
                                    `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                    `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                    `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                    PRIMARY KEY (`id`),
                                    KEY `title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='费用分类';

-- ----------------------------
-- Records of ea_cost_classify
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ea_cost_company
-- ----------------------------
DROP TABLE IF EXISTS `ea_cost_company`;
CREATE TABLE `ea_cost_company` (
                                   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                   `company_name` varchar(20) NOT NULL COMMENT '公司名称',
                                   `sort` int(11) DEFAULT '0' COMMENT '排序',
                                   `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
                                   `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                   `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                   `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                   `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                   PRIMARY KEY (`id`),
                                   UNIQUE KEY `title` (`company_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公司表';

-- ----------------------------
-- Records of ea_cost_company
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ea_cost_cost
-- ----------------------------
DROP TABLE IF EXISTS `ea_cost_cost`;
CREATE TABLE `ea_cost_cost` (
                                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                `cost_name` varchar(255) NOT NULL,
                                `company_name` varchar(255) NOT NULL,
                                `price` int(11) NOT NULL,
                                `delete_time` datetime DEFAULT NULL,
                                `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ea_cost_cost
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ea_cost_purchaselist
-- ----------------------------
DROP TABLE IF EXISTS `ea_cost_purchaselist`;
CREATE TABLE `ea_cost_purchaselist` (
                                        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                        `company_id` int(11) NOT NULL COMMENT '公司id',
                                        `classify_id` int(11) NOT NULL COMMENT '分类id',
                                        `time` int(11) NOT NULL COMMENT '日期',
                                        `purchase_name` varchar(255) NOT NULL COMMENT '采购名称',
                                        `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '单价',
                                        `number` int(11) NOT NULL DEFAULT '0' COMMENT '个数',
                                        `count_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
                                        `discount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠价格',
                                        `payment_name` varchar(255) DEFAULT NULL COMMENT '付款人',
                                        `reimbursement` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '报销(0:否,1:是)',
                                        `invoice` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发票(0:否，1是)',
                                        `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                        `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                        `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                        PRIMARY KEY (`id`),
                                        KEY `purchase_name` (`purchase_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购列表';

-- ----------------------------
-- Records of ea_cost_purchaselist
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ea_mall_cate
-- ----------------------------
DROP TABLE IF EXISTS `ea_mall_cate`;
CREATE TABLE `ea_mall_cate` (
                                `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                `title` varchar(20) NOT NULL COMMENT '分类名',
                                `image` varchar(500) DEFAULT NULL COMMENT '分类图片',
                                `sort` int(11) DEFAULT '0' COMMENT '排序',
                                `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
                                `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品分类';

-- ----------------------------
-- Records of ea_mall_cate
-- ----------------------------
BEGIN;
INSERT INTO `ea_mall_cate` VALUES (9, '手机', 'http://easy.web.com/upload/20210818/9dd1ec1484721a0d825f77143844172e.jpeg', 0, 1, '', 1589440437, 1629259120, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_mall_goods
-- ----------------------------
DROP TABLE IF EXISTS `ea_mall_goods`;
CREATE TABLE `ea_mall_goods` (
                                 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                 `cate_id` int(11) DEFAULT NULL COMMENT '分类ID',
                                 `title` varchar(20) NOT NULL COMMENT '商品名称',
                                 `logo` varchar(500) DEFAULT NULL COMMENT '商品logo',
                                 `images` text COMMENT '商品图片 以 | 做分割符号',
                                 `describe` text COMMENT '商品描述',
                                 `market_price` decimal(10,2) DEFAULT '0.00' COMMENT '市场价',
                                 `discount_price` decimal(10,2) DEFAULT '0.00' COMMENT '折扣价',
                                 `sales` int(11) DEFAULT '0' COMMENT '销量',
                                 `virtual_sales` int(11) DEFAULT '0' COMMENT '虚拟销量',
                                 `stock` int(11) DEFAULT '0' COMMENT '库存',
                                 `total_stock` int(11) DEFAULT '0' COMMENT '总库存',
                                 `sort` int(11) DEFAULT '0' COMMENT '排序',
                                 `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
                                 `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                 `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                 `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                 `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                 PRIMARY KEY (`id`),
                                 KEY `cate_id` (`cate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='商品列表';

-- ----------------------------
-- Records of ea_mall_goods
-- ----------------------------
BEGIN;
INSERT INTO `ea_mall_goods` VALUES (8, 10, '落地-风扇', 'http://admin.host/upload/20200514/a0f7fe9637abd219f7e93ceb2820df9b.jpg', 'http://admin.host/upload/20200514/95496713918290f6315ea3f87efa6bf2.jpg|http://admin.host/upload/20200514/ae29fa9cba4fc02defb7daed41cb2b13.jpg|http://admin.host/upload/20200514/f0a104d88ec7dc6fb42d2f87cbc71b76.jpg|http://admin.host/upload/20200514/3b88be4b1934690e5c1bd6b54b9ab5c8.jpg', '<p>76654757</p>\n\n<p><img alt=\"\" src=\"http://admin.host/upload/20200515/198070421110fa01f2c2ac2f52481647.jpg\" style=\"height:689px; width:790px\" /></p>\n\n<p><img alt=\"\" src=\"http://admin.host/upload/20200515/a07a742c15a78781e79f8a3317006c1d.jpg\" style=\"height:877px; width:790px\" /></p>\n', 599.00, 368.00, 0, 594, 0, 0, 675, 1, '', 1589454309, 1589567016, NULL);
INSERT INTO `ea_mall_goods` VALUES (9, 9, '电脑', 'http://admin.host/upload/20200514/bbf858d469dec2e12a89460110068d3d.jpg', 'http://admin.host/upload/20200514/f0a104d88ec7dc6fb42d2f87cbc71b76.jpg', '<p>477</p>\n', 0.00, 0.00, 0, 0, 115, 320, 0, 1, '', 1589465215, 1629775244, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_admin
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_admin`;
CREATE TABLE `ea_system_admin` (
                                   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                   `auth_ids` varchar(255) DEFAULT NULL COMMENT '角色权限ID',
                                   `head_img` varchar(255) DEFAULT NULL COMMENT '头像',
                                   `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户登录名',
                                   `password` char(40) NOT NULL DEFAULT '' COMMENT '用户登录密码',
                                   `phone` varchar(16) DEFAULT NULL COMMENT '联系手机号',
                                   `remark` varchar(255) DEFAULT '' COMMENT '备注说明',
                                   `login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
                                   `sort` int(11) DEFAULT '0' COMMENT '排序',
                                   `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用,)',
                                   `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                   `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                   `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                   PRIMARY KEY (`id`),
                                   UNIQUE KEY `username` (`username`) USING BTREE,
                                   KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统用户表';

-- ----------------------------
-- Records of ea_system_admin
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_admin` VALUES (1, NULL, '/static/admin/images/head.jpg', 'admin', 'a33b679d5581a8692988ec9f92ad2d6a2259eaa7', NULL, '', 24, 0, 1, 1629255280, 1632308319, NULL);
INSERT INTO `ea_system_admin` VALUES (2, '', 'http://easy.web.com/upload/20210818/2394a04bd587642a58e89e5c881ad27b.jpeg', 'admins', '', 'admins', 'admins', 0, 0, 0, 1629255501, 1629450418, 1629450418);
INSERT INTO `ea_system_admin` VALUES (3, '', 'http://easy.web.com/upload/20210818/9dd1ec1484721a0d825f77143844172e.jpeg', 'baimingl', '', '18518099053', 'Asdasd', 0, 0, 1, 1629450448, 1629450448, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_auth
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_auth`;
CREATE TABLE `ea_system_auth` (
                                  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                  `title` varchar(20) NOT NULL COMMENT '权限名称',
                                  `sort` int(11) DEFAULT '0' COMMENT '排序',
                                  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
                                  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                  PRIMARY KEY (`id`),
                                  UNIQUE KEY `title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统权限表';

-- ----------------------------
-- Records of ea_system_auth
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_auth` VALUES (1, '管理员', 1, 1, '测试管理员', 1588921753, 1589614331, NULL);
INSERT INTO `ea_system_auth` VALUES (6, '游客权限', 0, 1, '', 1588227513, 1589591751, 1589591751);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_auth_node
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_auth_node`;
CREATE TABLE `ea_system_auth_node` (
                                       `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                       `auth_id` bigint(20) unsigned DEFAULT NULL COMMENT '角色ID',
                                       `node_id` bigint(20) DEFAULT NULL COMMENT '节点ID',
                                       PRIMARY KEY (`id`),
                                       KEY `index_system_auth_auth` (`auth_id`) USING BTREE,
                                       KEY `index_system_auth_node` (`node_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色与节点关系表';

-- ----------------------------
-- Records of ea_system_auth_node
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_auth_node` VALUES (1, 6, 1);
INSERT INTO `ea_system_auth_node` VALUES (2, 6, 2);
INSERT INTO `ea_system_auth_node` VALUES (3, 6, 9);
INSERT INTO `ea_system_auth_node` VALUES (4, 6, 12);
INSERT INTO `ea_system_auth_node` VALUES (5, 6, 18);
INSERT INTO `ea_system_auth_node` VALUES (6, 6, 19);
INSERT INTO `ea_system_auth_node` VALUES (7, 6, 21);
INSERT INTO `ea_system_auth_node` VALUES (8, 6, 22);
INSERT INTO `ea_system_auth_node` VALUES (9, 6, 29);
INSERT INTO `ea_system_auth_node` VALUES (10, 6, 30);
INSERT INTO `ea_system_auth_node` VALUES (11, 6, 38);
INSERT INTO `ea_system_auth_node` VALUES (12, 6, 39);
INSERT INTO `ea_system_auth_node` VALUES (13, 6, 45);
INSERT INTO `ea_system_auth_node` VALUES (14, 6, 46);
INSERT INTO `ea_system_auth_node` VALUES (15, 6, 52);
INSERT INTO `ea_system_auth_node` VALUES (16, 6, 53);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_config
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_config`;
CREATE TABLE `ea_system_config` (
                                    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                                    `name` varchar(30) NOT NULL DEFAULT '' COMMENT '变量名',
                                    `group` varchar(30) NOT NULL DEFAULT '' COMMENT '分组',
                                    `value` text COMMENT '变量值',
                                    `remark` varchar(100) DEFAULT '' COMMENT '备注信息',
                                    `sort` int(10) DEFAULT '0',
                                    `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                    `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                    PRIMARY KEY (`id`),
                                    UNIQUE KEY `name` (`name`),
                                    KEY `group` (`group`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统配置表';

-- ----------------------------
-- Records of ea_system_config
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_config` VALUES (41, 'alisms_access_key_id', 'sms', '填你的', '阿里大于公钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (42, 'alisms_access_key_secret', 'sms', '填你的', '阿里大鱼私钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (55, 'upload_type', 'upload', 'local', '当前上传方式 （local,alioss,qnoss,txoss）', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (56, 'upload_allow_ext', 'upload', 'doc,gif,ico,icon,jpg,mp3,mp4,p12,pem,png,rar,jpeg', '允许上传的文件类型', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (57, 'upload_allow_size', 'upload', '1024000', '允许上传的大小', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (58, 'upload_allow_mime', 'upload', 'image/gif,image/jpeg,video/x-msvideo,text/plain,image/png', '允许上传的文件mime', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (59, 'upload_allow_type', 'upload', 'local,alioss,qnoss,txcos', '可用的上传文件方式', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (60, 'alioss_access_key_id', 'upload', '填你的', '阿里云oss公钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (61, 'alioss_access_key_secret', 'upload', '填你的', '阿里云oss私钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (62, 'alioss_endpoint', 'upload', '填你的', '阿里云oss数据中心', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (63, 'alioss_bucket', 'upload', '填你的', '阿里云oss空间名称', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (64, 'alioss_domain', 'upload', '填你的', '阿里云oss访问域名', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (65, 'logo_title', 'site', '管理后台', 'LOGO标题', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (66, 'logo_image', 'site', '/favicon.ico', 'logo图片', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (68, 'site_name', 'site', '行政管理系统', '站点名称', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (69, 'site_ico', 'site', '填你的', '浏览器图标', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (70, 'site_copyright', 'site', '个人所有', '版权信息', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (71, 'site_beian', 'site', '京ICP备2021029566号', '备案信息', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (72, 'site_version', 'site', '1.0.0', '版本信息', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (75, 'sms_type', 'sms', 'alisms', '短信类型', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (76, 'miniapp_appid', 'wechat', '填你的', '小程序公钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (77, 'miniapp_appsecret', 'wechat', '填你的', '小程序私钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (78, 'web_appid', 'wechat', '填你的', '公众号公钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (79, 'web_appsecret', 'wechat', '填你的', '公众号私钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (80, 'txcos_secret_id', 'upload', '填你的', '腾讯云cos密钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (81, 'txcos_secret_key', 'upload', '填你的', '腾讯云cos私钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (82, 'txcos_region', 'upload', '填你的', '存储桶地域', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (83, 'tecos_bucket', 'upload', '填你的', '存储桶名称', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (84, 'qnoss_access_key', 'upload', '填你的', '访问密钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (85, 'qnoss_secret_key', 'upload', '填你的', '安全密钥', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (86, 'qnoss_bucket', 'upload', '填你的', '存储空间', 0, NULL, NULL);
INSERT INTO `ea_system_config` VALUES (87, 'qnoss_domain', 'upload', '填你的', '访问域名', 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_menu`;
CREATE TABLE `ea_system_menu` (
                                  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                  `pid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
                                  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
                                  `icon` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单图标',
                                  `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
                                  `params` varchar(500) DEFAULT '' COMMENT '链接参数',
                                  `target` varchar(20) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
                                  `sort` int(11) DEFAULT '0' COMMENT '菜单排序',
                                  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
                                  `remark` varchar(255) DEFAULT NULL,
                                  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                  `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                  PRIMARY KEY (`id`),
                                  KEY `title` (`title`),
                                  KEY `href` (`href`)
) ENGINE=InnoDB AUTO_INCREMENT=263 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统菜单表';

-- ----------------------------
-- Records of ea_system_menu
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_menu` VALUES (227, 99999999, '后台首页', 'fa fa-home', 'index/welcome', '', '_self', 0, 1, NULL, NULL, 1573120497, NULL);
INSERT INTO `ea_system_menu` VALUES (228, 0, '系统管理', 'fa fa-cog', '', '', '_self', 0, 1, '', NULL, 1588999529, NULL);
INSERT INTO `ea_system_menu` VALUES (234, 228, '菜单管理', 'fa fa-tree', 'system.menu/index', '', '_self', 10, 1, '', NULL, 1588228555, NULL);
INSERT INTO `ea_system_menu` VALUES (244, 228, '管理员管理', 'fa fa-user', 'system.admin/index', '', '_self', 12, 1, '', 1573185011, 1588228573, NULL);
INSERT INTO `ea_system_menu` VALUES (245, 228, '角色管理', 'fa fa-bitbucket-square', 'system.auth/index', '', '_self', 11, 1, '', 1573435877, 1588228634, NULL);
INSERT INTO `ea_system_menu` VALUES (246, 228, '节点管理', 'fa fa-list', 'system.node/index', '', '_self', 9, 1, '', 1573435919, 1588228648, NULL);
INSERT INTO `ea_system_menu` VALUES (247, 228, '配置管理', 'fa fa-asterisk', 'system.config/index', '', '_self', 8, 1, '', 1573457448, 1588228566, NULL);
INSERT INTO `ea_system_menu` VALUES (248, 228, '上传管理', 'fa fa-arrow-up', 'system.uploadfile/index', '', '_self', 0, 1, '', 1573542953, 1588228043, NULL);
INSERT INTO `ea_system_menu` VALUES (249, 0, '商城管理', 'fa fa-list', '', '', '_self', 0, 0, '', 1589439884, 1631083561, NULL);
INSERT INTO `ea_system_menu` VALUES (250, 249, '商品分类', 'fa fa-calendar-check-o', 'mall.cate/index', '', '_self', 0, 1, '', 1589439910, 1589439966, NULL);
INSERT INTO `ea_system_menu` VALUES (251, 249, '商品管理', 'fa fa-list', 'mall.goods/index', '', '_self', 0, 1, '', 1589439931, 1589439942, NULL);
INSERT INTO `ea_system_menu` VALUES (252, 228, '快捷入口', 'fa fa-list', 'system.quick/index', '', '_self', 0, 1, '', 1589623683, 1589623683, NULL);
INSERT INTO `ea_system_menu` VALUES (253, 228, '日志管理', 'fa fa-connectdevelop', 'system.log/index', '', '_self', 0, 1, '', 1589623684, 1589623684, NULL);
INSERT INTO `ea_system_menu` VALUES (254, 0, '费用管理', 'fa fa-list', '', '', '_self', 1, 1, '', 1629256675, 1629430709, NULL);
INSERT INTO `ea_system_menu` VALUES (255, 254, '测试管理', 'fa fa-list', 'ceshi.ceshi/index', '', '_self', 0, 1, '', 1629256962, 1629430660, 1629430660);
INSERT INTO `ea_system_menu` VALUES (256, 254, '费用管理', 'fa fa-calculator', 'cost.cost/index', '', '_self', 0, 1, '', 1629431851, 1631083472, 1631083472);
INSERT INTO `ea_system_menu` VALUES (257, 254, '费用分类', 'fa fa-500px', 'cost.classify/index', '', '_self', 0, 1, '', 1629440207, 1629441681, NULL);
INSERT INTO `ea_system_menu` VALUES (258, 254, '公司管理', 'fa fa-align-left', 'cost.company/index', '', '_self', 0, 1, '', 1629446507, 1629446507, NULL);
INSERT INTO `ea_system_menu` VALUES (259, 254, 'ceshi', 'fa fa-list', 'cost.ceshi/index', '', '_self', 0, 1, '', 1629447321, 1629447409, 1629447409);
INSERT INTO `ea_system_menu` VALUES (260, 0, 'Asdasd', 'fa fa-list', '阿萨德看了萨迪克', '', '_self', 0, 1, '', 1629451134, 1629451160, 1629451160);
INSERT INTO `ea_system_menu` VALUES (261, 254, '采购明细', 'fa fa-calendar-check-o', 'cost.purchaselist/index', '', '_self', 1, 1, '', 1629691235, 1631167989, NULL);
INSERT INTO `ea_system_menu` VALUES (262, 254, '预算费用', 'fa fa-list', 'cost.budget/index', '', '_self', 2, 1, '', 1631167976, 1631167976, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_node
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_node`;
CREATE TABLE `ea_system_node` (
                                  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                                  `node` varchar(100) DEFAULT NULL COMMENT '节点代码',
                                  `title` varchar(500) DEFAULT NULL COMMENT '节点标题',
                                  `type` tinyint(1) DEFAULT '3' COMMENT '节点类型（1：控制器，2：节点）',
                                  `is_auth` tinyint(1) unsigned DEFAULT '1' COMMENT '是否启动RBAC权限控制',
                                  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
                                  `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
                                  PRIMARY KEY (`id`),
                                  KEY `node` (`node`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统节点表';

-- ----------------------------
-- Records of ea_system_node
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_node` VALUES (1, 'system.admin', '管理员管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (2, 'system.admin/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (3, 'system.admin/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (4, 'system.admin/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (5, 'system.admin/password', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (6, 'system.admin/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (7, 'system.admin/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (8, 'system.admin/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (9, 'system.auth', '角色权限管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (10, 'system.auth/authorize', '授权', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (11, 'system.auth/saveAuthorize', '授权保存', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (12, 'system.auth/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (13, 'system.auth/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (14, 'system.auth/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (15, 'system.auth/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (16, 'system.auth/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (17, 'system.auth/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (18, 'system.config', '系统配置管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (19, 'system.config/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (20, 'system.config/save', '保存', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (21, 'system.menu', '菜单管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (22, 'system.menu/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (23, 'system.menu/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (24, 'system.menu/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (25, 'system.menu/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (26, 'system.menu/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (27, 'system.menu/getMenuTips', '添加菜单提示', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (28, 'system.menu/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (29, 'system.node', '系统节点管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (30, 'system.node/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (31, 'system.node/refreshNode', '系统节点更新', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (32, 'system.node/clearNode', '清除失效节点', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (33, 'system.node/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (34, 'system.node/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (35, 'system.node/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (36, 'system.node/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (37, 'system.node/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (38, 'system.uploadfile', '上传文件管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (39, 'system.uploadfile/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (40, 'system.uploadfile/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (41, 'system.uploadfile/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (42, 'system.uploadfile/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (43, 'system.uploadfile/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (44, 'system.uploadfile/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (45, 'mall.cate', '商品分类管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (46, 'mall.cate/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (47, 'mall.cate/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (48, 'mall.cate/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (49, 'mall.cate/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (50, 'mall.cate/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (51, 'mall.cate/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (52, 'mall.goods', '商城商品管理', 1, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (53, 'mall.goods/index', '列表', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (54, 'mall.goods/stock', '入库', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (55, 'mall.goods/add', '添加', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (56, 'mall.goods/edit', '编辑', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (57, 'mall.goods/delete', '删除', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (58, 'mall.goods/export', '导出', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (59, 'mall.goods/modify', '属性修改', 2, 1, 1589580432, 1589580432);
INSERT INTO `ea_system_node` VALUES (60, 'system.quick', '快捷入口管理', 1, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (61, 'system.quick/index', '列表', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (62, 'system.quick/add', '添加', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (63, 'system.quick/edit', '编辑', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (64, 'system.quick/delete', '删除', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (65, 'system.quick/export', '导出', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (66, 'system.quick/modify', '属性修改', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (67, 'system.log', '操作日志管理', 1, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (68, 'system.log/index', '列表', 2, 1, 1589623188, 1589623188);
INSERT INTO `ea_system_node` VALUES (83, 'cost.cost', NULL, 1, 0, 1629432030, 1629446829);
INSERT INTO `ea_system_node` VALUES (85, 'cost.cost/add', '添加', 2, 1, 1629432030, 1629432030);
INSERT INTO `ea_system_node` VALUES (86, 'cost.cost/edit', '编辑', 2, 1, 1629432030, 1629432030);
INSERT INTO `ea_system_node` VALUES (87, 'cost.cost/delete', '删除', 2, 1, 1629432030, 1629432030);
INSERT INTO `ea_system_node` VALUES (88, 'cost.cost/export', '导出', 2, 1, 1629432030, 1629432030);
INSERT INTO `ea_system_node` VALUES (89, 'cost.cost/modify', '属性修改', 2, 1, 1629432030, 1629432030);
INSERT INTO `ea_system_node` VALUES (90, 'cost.classify', '费用分类', 1, 1, 1629440549, 1629446818);
INSERT INTO `ea_system_node` VALUES (93, 'cost.classify/edit', '编辑', 2, 1, 1629440549, 1629440549);
INSERT INTO `ea_system_node` VALUES (94, 'cost.classify/delete', '删除', 2, 1, 1629440549, 1629440549);
INSERT INTO `ea_system_node` VALUES (95, 'cost.classify/export', '导出', 2, 1, 1629440549, 1629440549);
INSERT INTO `ea_system_node` VALUES (96, 'cost.classify/modify', '属性修改', 2, 1, 1629440549, 1629440549);
INSERT INTO `ea_system_node` VALUES (97, 'cost.company', '公司管理', 1, 1, 1629447509, 1629448132);
INSERT INTO `ea_system_node` VALUES (98, 'cost.company/index', '列表', 2, 1, 1629447509, 1629447509);
INSERT INTO `ea_system_node` VALUES (99, 'cost.classify/index', '列表', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (100, 'cost.classify/add', '添加', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (101, 'cost.company/add', '添加', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (102, 'cost.company/edit', '编辑', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (103, 'cost.company/delete', '删除', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (104, 'cost.company/export', '导出', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (105, 'cost.company/modify', '属性修改', 2, 1, 1629447916, 1629447916);
INSERT INTO `ea_system_node` VALUES (106, 'cost.purchaselist', '采购明细', 1, 1, 1629691262, 1629691286);
INSERT INTO `ea_system_node` VALUES (107, 'cost.purchaselist/index', '列表', 2, 1, 1629691262, 1629691262);
INSERT INTO `ea_system_node` VALUES (108, 'cost.purchaselist/add', '添加', 2, 1, 1629691262, 1629691262);
INSERT INTO `ea_system_node` VALUES (109, 'cost.purchaselist/edit', '编辑', 2, 1, 1629691262, 1629691262);
INSERT INTO `ea_system_node` VALUES (110, 'cost.purchaselist/delete', '删除', 2, 1, 1629691262, 1629691262);
INSERT INTO `ea_system_node` VALUES (111, 'cost.purchaselist/export', '导出', 2, 1, 1629691262, 1629691262);
INSERT INTO `ea_system_node` VALUES (112, 'cost.purchaselist/modify', '属性修改', 2, 1, 1629691262, 1629691262);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_quick
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_quick`;
CREATE TABLE `ea_system_quick` (
                                   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                   `title` varchar(20) NOT NULL COMMENT '快捷入口名称',
                                   `icon` varchar(100) DEFAULT NULL COMMENT '图标',
                                   `href` varchar(255) DEFAULT NULL COMMENT '快捷链接',
                                   `sort` int(11) DEFAULT '0' COMMENT '排序',
                                   `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态(1:禁用,2:启用)',
                                   `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
                                   `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
                                   `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
                                   `delete_time` int(11) DEFAULT NULL COMMENT '删除时间',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统快捷入口表';

-- ----------------------------
-- Records of ea_system_quick
-- ----------------------------
BEGIN;
INSERT INTO `ea_system_quick` VALUES (1, '管理员管理', 'fa fa-user', 'system.admin/index', 0, 1, '', 1589624097, 1589624792, NULL);
INSERT INTO `ea_system_quick` VALUES (2, '角色管理', 'fa fa-bitbucket-square', 'system.auth/index', 0, 1, '', 1589624772, 1589624781, NULL);
INSERT INTO `ea_system_quick` VALUES (3, '菜单管理', 'fa fa-tree', 'system.menu/index', 0, 1, NULL, 1589624097, 1589624792, NULL);
INSERT INTO `ea_system_quick` VALUES (6, '节点管理', 'fa fa-list', 'system.node/index', 0, 1, NULL, 1589624772, 1589624781, NULL);
INSERT INTO `ea_system_quick` VALUES (7, '配置管理', 'fa fa-asterisk', 'system.config/index', 0, 1, NULL, 1589624097, 1589624792, NULL);
INSERT INTO `ea_system_quick` VALUES (8, '上传管理', 'fa fa-arrow-up', 'system.uploadfile/index', 0, 1, NULL, 1589624772, 1589624781, NULL);
INSERT INTO `ea_system_quick` VALUES (10, '商品分类', 'fa fa-calendar-check-o', 'mall.cate/index', 0, 1, NULL, 1589624097, 1589624792, NULL);
INSERT INTO `ea_system_quick` VALUES (11, '商品管理', 'fa fa-list', 'mall.goods/index', 0, 1, NULL, 1589624772, 1589624781, NULL);
COMMIT;

-- ----------------------------
-- Table structure for ea_system_uploadfile
-- ----------------------------
DROP TABLE IF EXISTS `ea_system_uploadfile`;
CREATE TABLE `ea_system_uploadfile` (
                                        `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                        `upload_type` varchar(20) NOT NULL DEFAULT 'local' COMMENT '存储位置',
                                        `original_name` varchar(255) DEFAULT NULL COMMENT '文件原名',
                                        `url` varchar(255) NOT NULL DEFAULT '' COMMENT '物理路径',
                                        `image_width` varchar(30) NOT NULL DEFAULT '' COMMENT '宽度',
                                        `image_height` varchar(30) NOT NULL DEFAULT '' COMMENT '高度',
                                        `image_type` varchar(30) NOT NULL DEFAULT '' COMMENT '图片类型',
                                        `image_frames` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
                                        `mime_type` varchar(100) NOT NULL DEFAULT '' COMMENT 'mime类型',
                                        `file_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
                                        `file_ext` varchar(100) DEFAULT NULL,
                                        `sha1` varchar(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
                                        `create_time` int(10) DEFAULT NULL COMMENT '创建日期',
                                        `update_time` int(10) DEFAULT NULL COMMENT '更新时间',
                                        `upload_time` int(10) DEFAULT NULL COMMENT '上传时间',
                                        PRIMARY KEY (`id`),
                                        KEY `upload_type` (`upload_type`),
                                        KEY `original_name` (`original_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='上传文件表';

-- ----------------------------
-- Records of ea_system_uploadfile
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
